query("SELECT * FROM metalar WHERE Id = '1'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["description"];
} elseif ($_GET["page"] == "acil"){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '2'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["description"];
} elseif ($_GET["page"] == "magazalar"){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '3'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["description"];
} elseif ($_GET["page"] == "sayfa"){
if ($_GET["id"] == "1"){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '4'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
} elseif ($_GET["id"] == 2){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '6'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
} elseif ($_GET["id"] == 3){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '7'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
} elseif ($_GET["id"] == 4){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '8'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
} elseif ($_GET["id"] == 5){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '9'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
} elseif ($_GET["id"] == 6){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '10'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
} elseif ($_GET["id"] == 7){
$sql = $db->query("SELECT * FROM metalar WHERE Id = '11'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
}
$title = $a["title"];
$description = $a["description"];
} elseif ($_GET["page"] == "category"){
$id = $_GET["id"];
$sql = $db->query("SELECT * FROM category WHERE Id = '$id'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["kategori_adi"]." İlanları";
$description = $a["kategori_adi"]." İlanları";
} elseif ($_GET["page"] == "blog"){
$id = $_GET["id"];
$sql = $db->query("SELECT * FROM bkategoriler WHERE Id = '$id'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["title"];
if ($id == ""){
$title = "Blog";
$description = "Blog";
}
} elseif ($_GET["page"] == "yazi"){
$id = $_GET["id"];
$sql = $db->query("SELECT * FROM byazilar WHERE Id = '$id'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["title"];
} elseif ($_GET["page"] == "ilan"){
$id = $_GET["id"];
$sql = $db->query("SELECT * FROM ilanlar WHERE Id = '$id'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["title"];
} else {
$sql = $db->query("SELECT * FROM metalar WHERE Id = '12'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["description"];
}
$sql = $db->query("SELECT * FROM genel");
$a22 = $sql->fetch(PDO::FETCH_ASSOC);
$keywords2 = $a22["keywords"];
$description2 = $a22["description"];
?>
<? echo $title; ?>
query("SELECT * FROM ilanlar WHERE Id = '$id'");
$a = $sql->fetch(PDO::FETCH_ASSOC);
$title = $a["title"];
$description = $a["title"];
$resim = $db->query("SELECT * FROM images WHERE ilanId = '{$id}' ORDER BY s ASC LIMIT 1");
if ($resim->rowCount() == 0) {
$src = "img/no.png";
} else {
$r = $resim->fetch(PDO::FETCH_ASSOC);
$src = $base_url . "fileserver/files/" . $a["Id"] . "/" . $r["name"];
}
echo '
';
}
?>